home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 9 / developer source - volume 9.iso / dbmsa / aug96 / kimbf102.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  48.5 KB  |  323x379  |  4-bit (16 colors)
   ocr: Purchase Order Daily Time FactTable Dimension Table Day Key / Day Key Product Key Day Vendor Key Week Dollar Cost Fiscal Period Number Ordered Days Roli Upto Retail Sales Weekly Time Weeks Fact Table Dimension Table Week Key - Week Key Product Key Week Store Key Fiscal Period Dollars Sold Number Sold Figure 2. This example shows two data marts with contormed time tables. Reports can be done starting at a weekly level in which intormation from the two fact tables is combined.